CREATE PROCEDURE GetFromPersonalByDni
@DNI varchar(8)
AS
BEGIN
SELECT *
FROM Personal
WHERE upper(DNI) LIKE upper('%'+@DNI+'%')
END